<?php
/**
 * Created by PhpStorm.
 * User: yangchunrun
 * Date: 17/3/21
 * Time: 下午5:40
 */
if(!defined('IN_DISCUZ')) {
    exit('Access Denied');
}

$sql = <<<EOF

DROP TABLE IF EXISTS pre_common_attach_qrcode;
CREATE TABLE pre_common_attach_qrcode (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `aid` mediumint(8) unsigned NOT NULL default '0',
  `code1` char(6) NOT NULL default '',
  `code2` char(6) NOT NULL default '',
  `need_pay` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `createtime` int(10) unsigned NOT NULL
)ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS pre_thinker_wx_keyword (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `keyword` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `res_id` int(10) unsigned default '0',
   `status` tinyint(1) unsigned NOT NULL DEFAULT 0,
   `is_match` tinyint(1) unsigned NOT NULL DEFAULT 0,
   `type` tinyint(1) unsigned NOT NULL DEFAULT 0,
   `order_num` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `createtime` int(10) unsigned NOT NULL,

  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=MYISAM;
EOF;

runquery($sql);

$finish = TRUE;
?>